In [1]:
In [2]:
In [3]:
In [4]:
In [5]:
In [6]:
In [7]:
In [8]:
Jul 2020Jan 2021Jul 2021Jan 2022Jul 2022Jan 2023Jul 2023020M40M60M80M100M120M140M
total_vaccinations Over TimeDatetotal_vaccinations
In [9]:
202020212022202301M2M3M4M5M6M7M202020212022202302B4B6B8B10B12B14B
Total DeathsTotal VaccinatedTotal Deaths and Total Vaccinated Over TimeDateCountsTotal DeathsTotal DeathsTotal Vaccinated
In [10]:
In [11]:
In [12]:
In [13]:
In [14]:
In [15]:
             date  total_deaths  population  death_rate_per_1000  \
0      2020-01-03           NaN  41128772.0                  NaN   
1      2020-01-04           NaN  41128772.0                  NaN   
2      2020-01-05           NaN  41128772.0                  NaN   
3      2020-01-06           NaN  41128772.0                  NaN   
4      2020-01-07           NaN  41128772.0                  NaN   
...           ...           ...         ...                  ...   
350044 2023-10-14        5718.0  16320539.0             0.350356   
350045 2023-10-15        5718.0  16320539.0             0.350356   
350046 2023-10-16        5718.0  16320539.0             0.350356   
350047 2023-10-17        5718.0  16320539.0             0.350356   
350048 2023-10-18        5718.0  16320539.0             0.350356   

        death_rate_per_100000  
0                         NaN  
1                         NaN  
2                         NaN  
3                         NaN  
4                         NaN  
...                       ...  
350044              35.035608  
350045              35.035608  
350046              35.035608  
350047              35.035608  
350048              35.035608  

[350049 rows x 5 columns]
In [16]:
In [17]:
In [18]:
In [19]:
location
Afghanistan         2021-02-28
Africa              2021-01-13
Albania             2021-01-12
Algeria             2021-01-30
Andorra             2021-01-25
                       ...    
Wallis and Futuna   2021-03-23
World               2020-12-04
Yemen               2021-05-09
Zambia              2021-04-15
Zimbabwe            2021-02-18
Name: date, Length: 235, dtype: datetime64[ns]
In [20]:
In [21]:
In [22]:
In [23]:
In [24]:
Index(['iso_code', 'continent', 'location', 'date', 'total_cases', 'new_cases',
       'new_cases_smoothed', 'total_deaths', 'new_deaths',
       'new_deaths_smoothed', 'total_cases_per_million',
       'new_cases_per_million', 'new_cases_smoothed_per_million',
       'total_deaths_per_million', 'new_deaths_per_million',
       'new_deaths_smoothed_per_million', 'reproduction_rate', 'icu_patients',
       'icu_patients_per_million', 'hosp_patients',
       'hosp_patients_per_million', 'weekly_icu_admissions',
       'weekly_icu_admissions_per_million', 'weekly_hosp_admissions',
       'weekly_hosp_admissions_per_million', 'total_tests', 'new_tests',
       'total_tests_per_thousand', 'new_tests_per_thousand',
       'new_tests_smoothed', 'new_tests_smoothed_per_thousand',
       'positive_rate', 'tests_per_case', 'tests_units', 'total_vaccinations',
       'people_vaccinated', 'people_fully_vaccinated', 'total_boosters',
       'new_vaccinations', 'new_vaccinations_smoothed',
       'total_vaccinations_per_hundred', 'people_vaccinated_per_hundred',
       'people_fully_vaccinated_per_hundred', 'total_boosters_per_hundred',
       'new_vaccinations_smoothed_per_million',
       'new_people_vaccinated_smoothed',
       'new_people_vaccinated_smoothed_per_hundred', 'stringency_index',
       'population_density', 'median_age', 'aged_65_older', 'aged_70_older',
       'gdp_per_capita', 'extreme_poverty', 'cardiovasc_death_rate',
       'diabetes_prevalence', 'female_smokers', 'male_smokers',
       'handwashing_facilities', 'hospital_beds_per_thousand',
       'life_expectancy', 'human_development_index', 'population',
       'excess_mortality_cumulative_absolute', 'excess_mortality_cumulative',
       'excess_mortality', 'excess_mortality_cumulative_per_million',
       'z_score', 'death_rate_per_1000', 'death_rate_per_100000',
       'death_rate_per_100', 'vaccine_rate_per_100'],
      dtype='object')
In [25]:
Size on Disk: 87.62 MB
Number of Records: 350049
In [26]:
               location  total_deaths
0                 World     6972139.0
1           High income     2914272.0
2   Upper middle income     2666760.0
3                Europe     2079783.0
4                  Asia     1633880.0
5         North America     1613118.0
6         South America     1356419.0
7   Lower middle income     1339160.0
8        European Union     1245398.0
9         United States     1136920.0
10               Brazil      704659.0
11                India      532037.0
12               Russia      400102.0
13               Mexico      334699.0
14               Africa      259023.0
15       United Kingdom      230383.0
16                 Peru      221704.0
17                Italy      192013.0
18              Germany      174979.0
19               France      167985.0
In [27]:
          location  total_deaths
0    United States     1136920.0
1           Brazil      704659.0
2            India      532037.0
3           Russia      400102.0
4           Mexico      334699.0
5           Africa      259023.0
6   United Kingdom      230383.0
7             Peru      221704.0
8            Italy      192013.0
9          Germany      174979.0
10          France      167985.0
11       Indonesia      161918.0
12            Iran      146480.0
13        Colombia      142942.0
14       Argentina      130472.0
15           Spain      121852.0
16           China      121742.0
17          Poland      119655.0
18         Ukraine      109918.0
19    South Africa      102595.0
          location  total_deaths
0    United States     1136920.0
1           Brazil      704659.0
2            India      532037.0
3           Russia      400102.0
4           Mexico      334699.0
5           Africa      259023.0
6   United Kingdom      230383.0
7             Peru      221704.0
8            Italy      192013.0
9          Germany      174979.0
10          France      167985.0
11       Indonesia      161918.0
12            Iran      146480.0
13        Colombia      142942.0
14       Argentina      130472.0
15           Spain      121852.0
16           China      121742.0
17          Poland      119655.0
18         Ukraine      109918.0
19    South Africa      102595.0
In [28]:
{'United States', 'Iran', 'India', 'Africa', 'United Kingdom', 'Brazil', 'France', 'Germany', 'Mexico', 'Indonesia', 'Russia', 'China'}
In [29]:
Top 10 Common Locations with Highest Deaths:
          location  total_deaths
0    United States     1136920.0
1           Brazil      704659.0
2            India      532037.0
3           Russia      400102.0
4           Mexico      334699.0
5           Africa      259023.0
6   United Kingdom      230383.0
7          Germany      174979.0
8           France      167985.0
9        Indonesia      161918.0
10            Iran      146480.0
11           China      121742.0

Top 10 Common Locations with Highest Vaccinations:
          location  total_vaccinations
0            China        3.491077e+09
1            India        2.206747e+09
2           Africa        8.553188e+08
3    United States        6.767288e+08
4           Brazil        4.864364e+08
5        Indonesia        4.475958e+08
6           Mexico        2.231590e+08
7          Germany        1.922215e+08
8           Russia        1.873745e+08
9             Iran        1.554458e+08
10          France        1.544933e+08
11  United Kingdom        1.512488e+08
In [39]:
In [ ]: